dataSource {
    pooled = true
    driverClassName = "org.hsqldb.jdbcDriver"
    username = "sa"
    password = ""
}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = true
    cache.provider_class = 'com.opensymphony.oscache.hibernate.OSCacheProvider'
}
// environment specific settings
environments {
    development {
        dataSource {
            dbCreate = "create-drop" // one of 'create', 'create-drop','update'
//            url = "jdbc:hsqldb:mem:devDB"
            url = "jdbc:mysql://localhost/soccerChatDev?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8"
            driverClassName = "com.mysql.jdbc.Driver"
            dialect = "org.hibernate.dialect.MySQL5Dialect"
            username = "root"
            password = "541116"
        }
    }
    test {
        dataSource {
            dbCreate = "update"
//            url = "jdbc:hsqldb:mem:testDb"
            url = "jdbc:mysql://localhost/soccerChatTest?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8"
            driverClassName = "com.mysql.jdbc.Driver"
            dialect = "org.hibernate.dialect.MySQL5Dialect"
            username = "root"
            password = "541116"
        }
    }
    production {
        dataSource {
            dbCreate = "update"
            url = "jdbc:mysql://10.254.110.95/db_1_6109"
            driverClassName = "com.mysql.jdbc.Driver"
            dialect = "org.hibernate.dialect.MySQL5Dialect"
            username = "user_6109"
            password = "8fnyyscs"
        }
    }
}